Release 10.1A: OpenEdge Data Management:
SQL Development

ROLLBACK statement

The ROLLBACK statement undoes all the changes made to the database within a transaction. The ROLLBACK statement uses the following syntax:

Syntax

ROLLBACK [ WORK ];

The following example shows how to use the ROLLBACK statement:

ROLLBACK WORK ;

Notes: The ROLLBACK statement does not affect the contents of any host variables or the flow of control in the program.

The database issues a ROLLBACK operation automatically when there is an abnormal termination of the application program.

For more on the ROLLBACK statement, see OpenEdge Data Management: SQL Reference .